﻿CREATE PROCEDURE [dbo].[proc_Company_GetID]
	(
		@UserName nvarchar(50),
		@CompanyId int output
	)
AS
	Select @CompanyId=CompanyId from aspnet_Users Where UserName=@UserName
	RETURN @CompanyId
